CREATE TABLE [dbo].[StoreNuke_StoreControls] (
	[StoreControlID] [int] IDENTITY (1, 1) NOT NULL ,
	[StoreControlName] [nvarchar] (50) NOT NULL ,
	[StoreControlPath] [nvarchar] (100) NOT NULL ,
	[StoreControlAdminPath] [nvarchar] (100) NOT NULL ,
	[StoreControlHelp] [Text] NOT NULL 	
) ON [PRIMARY]
GO

CREATE TABLE [StoreNuke_GeneralAdministration] (
	[DefaultPageTitle] [nvarchar] (50) NOT NULL ,
	[DefaultMetaDesc] [nvarchar] (1000) NOT NULL ,
	[DefaultMetaKey] [nvarchar] (1000) NOT NULL ,
	[SkinPath] [nvarchar] (100) NOT NULL ,
	[SSLEnabled] [bit] NOT NULL ,
	[LogoPath] [nvarchar] (100) NOT NULL ,
	[GatewayPath] [nvarchar] (100) NOT NULL ,
	[DefaultEmailAddress] [nvarchar] (50) NOT NULL ,
	[Copyright] [nvarchar] (50) NOT NULL ,
	[Terms] [text] NOT NULL ,
	[Privacy] [text] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [StoreNuke_StoreControlSettings] (
	[StoreControlID] [int] NOT NULL ,
	[SettingName] [nvarchar] (50) NOT NULL ,
	[SettingValue] [nvarchar] (3900) NOT NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_AddStoreControl 
(
	@StoreControlName nvarchar(50), 
	@StoreControlPath nvarchar(100), 
	@StoreControlAdminPath nvarchar(100),
	@StoreControlHelp Text
)
AS
INSERT INTO StoreNuke_StoreControls
(StoreControlName, StoreControlPath, StoreControlAdminPath, StoreControlHelp)
VALUES
(@StoreControlName, @StoreControlPath, @StoreControlAdminPath, @StoreControlHelp)
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_GetSkinPath 
AS
SELECT
	SkinPath
FROM
	StoreNuke_GeneralAdministration
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_GetGatewayPath 
AS
SELECT
	GatewayPath
FROM
	StoreNuke_GeneralAdministration
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_GetStoreControl 
(
	@StoreControlID int
)
AS
SELECT
	StoreControlID,
	StoreControlName,
	StoreControlPath,
	StoreControlAdminPath,
	StoreControlHelp
FROM
	StoreNuke_StoreControls
WHERE
	StoreControlID = @StoreControlID
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_GetStoreControls 
AS
SELECT
	StoreControlID,
	StoreControlName,
	StoreControlPath,
	StoreControlAdminPath,
	StoreControlHelp
FROM
	StoreNuke_StoreControls
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_UpdateSkinPath 
	@SkinPath nvarchar(100)
AS
Update StoreNuke_GeneralAdministration
SET
	SkinPath = @SkinPath
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE StoreNuke_UpdateStoreControl 
(
	@StoreControlID int,
	@StoreControlName nvarchar(50), 
	@StoreControlPath nvarchar(100), 
	@StoreControlAdminPath nvarchar(100)
)
AS
UPDATE StoreNuke_StoreControls
SET
	StoreControlName = @StoreControlName,
	StoreControlPath = @StoreControlPath,
	StoreControlAdminPath = @StoreControlAdminPath
WHERE
	StoreControlID = @StoreControlID
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_UpdateTerms
(
	@Terms text
)
AS

UPDATE StoreNuke_GeneralAdministration
SET
   Terms = @Terms

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_UpdatePrivacy
(
	@Privacy text
)
AS

UPDATE StoreNuke_GeneralAdministration
SET
   Privacy = @Privacy

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_GetGeneralAdministration
AS
SELECT 
   DefaultPageTitle, 
   DefaultMetaDesc, 
   DefaultMetaKey, 
   SSLEnabled, 
   LogoPath, 
   GatewayPath, 
   DefaultEmailAddress,
   Copyright
   
FROM StoreNuke_GeneralAdministration

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_UpdateGeneralAdministration
(
	@DefaultPageTitle nvarchar (50), 
	@DefaultMetaDesc nvarchar (1000), 
	@DefaultMetaKey nvarchar (1000), 
	@SSLEnabled bit, 
	@LogoPath nvarchar (100), 
	@GatewayPath nvarchar (100), 
	@DefaultEmailAddress nvarchar (50),
	@Copyright nvarchar (50)
)
AS

UPDATE StoreNuke_GeneralAdministration
SET
   DefaultPageTitle = @DefaultPageTitle, 
   DefaultMetaDesc = @DefaultMetaDesc, 
   DefaultMetaKey = @DefaultMetaKey, 
   SSLEnabled = @SSLEnabled, 
   LogoPath = @LogoPath, 
   GatewayPath = @GatewayPath,
   DefaultEmailAddress = @DefaultEmailAddress,
   Copyright = @Copyright

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_GetPrivacy
AS

SELECT Privacy
FROM StoreNuke_GeneralAdministration

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_GetCopyright
AS

SELECT Copyright
FROM StoreNuke_GeneralAdministration

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE Procedure StoreNuke_GetTerms
AS

SELECT Terms
FROM StoreNuke_GeneralAdministration

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROC StoreNuke_GetStoreControlSettings
(
	@StoreControlID int
)
AS
SELECT
	SettingName, SettingValue
FROM
	StoreNuke_StoreControlSettings
WHERE
	StoreControlID = @StoreControlID
GO


SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROC StoreNuke_AddUpateStoreControlSettings
(
	@StoreControlID int,
	@SettingName nvarchar(50),
	@SettingValue nvarchar(4000)
)
AS
DECLARE @Count int
SELECT
	@Count = Count(StoreControlID)
FROM
	StoreNuke_StoreControlSettings
WHERE
	StoreControlID = @StoreControlID AND
	SettingName = @SettingName
IF @Count > 0

UPDATE StoreNuke_StoreControlSettings
SET
	SettingValue = @SettingValue
WHERE
	StoreControlID = @StoreControlID AND
	SettingName = @SettingName
ELSE

INSERT INTO StoreNuke_StoreControlSettings
(StoreControlID, SettingName, SettingValue)
VALUES
(@StoreControlID, @SettingName, @SettingValue)
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE Procedure StoreNuke_GetSingleProductCategory
(
    @categoryID int 
)
AS
SELECT 
    CategoryName,
    CategoryDescription,
    Archived

FROM 
    StoreNuke_Categories

WHERE
    categoryID = @categoryID
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE StoreNuke_AddProduct
(
	@CategoryID int, 
	@ModelNumber nvarchar (50), 
	@ModelName nvarchar (50), 
	@ProductImage nvarchar (50),
	@UnitCost money, 
	@Description Text ,
	@Archived bit
)
AS
INSERT INTO [StoreNuke_Products]
([CategoryID], [ModelNumber], [ModelName], [ProductImage], [UnitCost], [Description], [Archived])
VALUES
(@CategoryID, @ModelNumber, @ModelName, @ProductImage, @UnitCost, @Description, @Archived)
GO

CREATE PROCEDURE StoreNuke_UpdateProduct
(
	@ProductID int,
	@CategoryID int, 
	@ModelNumber nvarchar (50), 
	@ModelName nvarchar (50), 
	@ProductImage nvarchar (50),
	@UnitCost money, 
	@Description Text ,
	@Archived bit 
)
AS
UPDATE [StoreNuke_Products]
SET  
	[CategoryID]=@CategoryID, 
	[ModelNumber]=@ModelNumber, 
	[ModelName]=@ModelName,
	[ProductImage]=@ProductImage,
	[UnitCost]=@UnitCost,
	[Description]=@Description,
	[Archived]=@Archived
WHERE 
	ProductID = @ProductID

GO

CREATE PROCEDURE StoreNuke_DeleteProduct
(
	@ProductID int,
	@Message int out
)
AS
declare @iCount int

select @iCount  = Count(ProductID) from StoreNuke_OrderDetails where ProductID = @ProductID

select @Message  =  @iCount

If @iCount  = 0

DELETE FROM 
	[StoreNuke_Products]
WHERE 
	ProductID = @ProductID

GO

INSERT INTO StoreNuke_GeneralAdministration
	(DefaultPageTitle, DefaultMetaDesc, DefaultMetaKey, SkinPath, SSLEnabled, LogoPath, GatewayPath, DefaultEmailAddress, Copyright, Terms, Privacy)
VALUES
	('StoreNuke Starter Kit','StoreNuke: The New Commerce Starter for Professionals','Store,ECommerce,WillowTree','Skins/StoreNuke/StoreNuke.ascx',0,'StoreLogo.gif','WillowTreeSoftware.PayPal.Gateway','admin@storenuke.net','Copyright 2005 StoreNuke','
<P><SPAN class=Normal><SPAN class=SubHead>AGREEMENT BETWEEN USER AND [STORENAME]</SPAN><BR><BR>The [STORENAME] Web Site is comprised of various Web pages operated by [STORENAME].<BR><BR>The [STORENAME] Web Site is offered to you conditioned on your acceptance without modification of the terms, conditions, and notices contained herein. 
Your use of the [STORENAME] Web Site constitutes your agreement to all such terms, conditions, and notices.<BR><BR><SPAN class=SubHead>MODIFICATION OF THESE TERMS OF USE</SPAN><BR><BR>
[STORENAME] reserves the right to change the terms, conditions, and notices under which the [STORENAME] Web Site is offered, including but not limited to the charges associated with the use of the [STORENAME] 
Web Site.<BR><BR><SPAN class=SubHead>LINKS TO THIRD PARTY SITES</SPAN><BR><BR>The [STORENAME] Web Site may contain links to other Web Sites ("Linked Sites"). The Linked Sites are not under the control of [STORENAME] and 
[STORENAME] is not responsible for the contents of any Linked Site, including without limitation any link contained in a Linked Site, or any changes or updates to a Linked Site. 
[STORENAME] is not responsible for webcasting or any other form of transmission received from any Linked Site. [STORENAME] is providing these links to you only as a convenience, and the 
inclusion of any link does not imply endorsement by [STORENAME] of the site or any association with its operators.<BR><BR><SPAN class=SubHead>NO UNLAWFUL OR PROHIBITED USE</SPAN><BR><BR>
As a condition of your use of the [STORENAME] Web Site, you warrant to [STORENAME] that you will not use the [STORENAME] Web Site for any purpose that is unlawful or prohibited by these terms, 
conditions, and notices. You may not use the [STORENAME] Web Site in any manner which could damage, disable, overburden, or impair the [STORENAME] Web Site or interfere with any other party''s 
use and enjoyment of the [STORENAME] Web Site. You may not obtain or attempt to obtain any materials or information through any means not intentionally made available or provided for through the 
[STORENAME] Web Sites.<BR><BR><SPAN class=SubHead>USE OF COMMUNICATION SERVICES</SPAN><BR><BR>The [STORENAME] Web Site may contain bulletin board services, chat areas, news groups, forums, 
communities, personal web pages, calendars, and/or other message or communication facilities designed to enable you to communicate with the public at large or with a group 
(collectively, "Communication Services"), you agree to use the Communication Services only to post, send and receive messages and material that are proper and related to the particular 
Communication Service. By way of example, and not as a limitation, you agree that when using a Communication Service, you will not:<BR><BR></P>
<UL><LI>Defame, abuse, harass, stalk, threaten or otherwise violate the legal rights (such as rights of privacy and publicity) of others.<BR><BR>
<LI>Publish, post, upload, distribute or disseminate any inappropriate, profane, defamatory, infringing, obscene, indecent or unlawful topic, name, material or information.<BR><BR>
<LI>Upload files that contain software or other material protected by intellectual property laws (or by rights of privacy of publicity) unless you own or control the rights thereto or have received all necessary consents.<BR><BR>
<LI>Upload files that contain viruses, corrupted files, or any other similar software or programs that may damage the operation of another''s computer.<BR><BR>
<LI>Advertise or offer to sell or buy any goods or services for any business purpose, unless such Communication Service specifically allows such messages.<BR><BR>
<LI>Conduct or forward surveys, contests, pyramid schemes or chain letters.<BR><BR>
<LI>Download any file posted by another user of a Communication Service that you know, or reasonably should know, cannot be legally distributed in such manner.<BR><BR>
<LI>Falsify or delete any author attributions, legal or other proper notices or proprietary designations or labels of the origin or source of software or other material contained in a file that is uploaded.<BR><BR>
<LI>Restrict or inhibit any other user from using and enjoying the Communication Services.<BR><BR>
<LI>Violate any code of conduct or other guidelines which may be applicable for any particular Communication Service.<BR><BR>
<LI>Harvest or otherwise collect information about others, including e-mail addresses, without their consent.<BR><BR>
<LI>Violate any applicable laws or regulations. </LI></UL>
<P>[STORENAME] has no obligation to monitor the Communication Services. However, [STORENAME] reserves the right to review materials posted to a Communication Service and to remove any materials in its sole discretion. 
[STORENAME] reserves the right to terminate your access to any or all of the Communication Services at any time without notice for any reason whatsoever.<BR><BR>
[STORENAME] reserves the right at all times to disclose any information as necessary to satisfy any applicable law, regulation, legal process or governmental request, 
or to edit, refuse to post or to remove any information or materials, in whole or in part, in [STORENAME]''s sole discretion.<BR><BR>Always use caution when giving out any personally 
identifying information about yourself or your children in any Communication Service. [STORENAME] does not control or endorse the content, messages or information found in any Communication 
Service and, therefore, [STORENAME] specifically disclaims any liability with regard to the Communication Services and any actions resulting from your participation in any Communication Service. 
Managers and hosts are not authorized [STORENAME] spokespersons, and their views do not necessarily reflect those of [STORENAME].<BR><BR>Materials uploaded to a Communication Service may be 
subject to posted limitations on usage, reproduction and/or dissemination. You are responsible for adhering to such limitations if you download the materials.<BR><BR><SPAN class=SubHead>
MATERIALS PROVIDED TO [STORENAME] OR POSTED AT ANY [STORENAME] WEB SITE</SPAN><BR><BR>[STORENAME] does not claim ownership of the materials you provide to [STORENAME] (including feedback and 
suggestions) or post, upload, input or submit to any [STORENAME] Web Site or its associated services (collectively "Submissions"). However, by posting, uploading, inputting, providing or 
submitting your Submission you are granting [STORENAME], its affiliated companies and necessary sublicensees permission to use your Submission in connection with the operation of their Internet 
businesses including, without limitation, the rights to: copy, distribute, transmit, publicly display, publicly perform, reproduce, edit, translate and reformat your Submission; and to publish 
your name in connection with your Submission.<BR><BR>No compensation will be paid with respect to the use of your Submission, as provided herein. [STORENAME] is under no obligation to post or 
use any Submission you may provide and may remove any Submission at any time in [STORENAME]''s sole discretion.<BR><BR>By posting, uploading, inputting, providing or submitting your Submission 
you warrant and represent that you own or otherwise control all of the rights to your Submission as described in this section including, without limitation, all the rights necessary for you to 
provide, post, upload, input or submit the Submissions.<BR><BR><SPAN class=SubHead>LIABILITY DISCLAIMER</SPAN><BR><BR>THE INFORMATION, SOFTWARE, PRODUCTS, AND SERVICES INCLUDED IN OR AVAILABLE 
THROUGH THE [STORENAME] WEB SITE MAY INCLUDE INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. [STORENAME] AND/OR ITS SUPPLIERS MAY MAKE 
IMPROVEMENTS AND/OR CHANGES IN THE [STORENAME] WEB SITE AT ANY TIME. ADVICE RECEIVED VIA THE [STORENAME] WEB SITE SHOULD NOT BE RELIED UPON FOR PERSONAL, MEDICAL, LEGAL OR FINANCIAL DECISIONS 
AND YOU SHOULD CONSULT AN APPROPRIATE PROFESSIONAL FOR SPECIFIC ADVICE TAILORED TO YOUR SITUATION.<BR><BR>[STORENAME] AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY, 
RELIABILITY, AVAILABILITY, TIMELINESS, AND ACCURACY OF THE INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS CONTAINED ON THE [STORENAME] WEB SITE FOR ANY PURPOSE. TO THE MAXIMUM 
EXTENT PERMITTED BY APPLICABLE LAW, ALL SUCH INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS ARE PROVIDED "AS IS" WITHOUT WARRANTY OR CONDITION OF ANY KIND. [STORENAME] AND/OR 
ITS SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS, INCLUDING ALL IMPLIED WARRANTIES OR CONDITIONS 
OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT.<BR><BR>TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL [STORENAME] AND/OR ITS SUPPLIERS 
BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, SPECIAL, CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF USE, DATA OR PROFITS, 
ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OR PERFORMANCE OF THE [STORENAME] WEB SITE, WITH THE DELAY OR INABILITY TO USE THE [STORENAME] WEB SITE OR RELATED SERVICES, 
THE PROVISION OF OR FAILURE TO PROVIDE SERVICES, OR FOR ANY INFORMATION, SOFTWARE, PRODUCTS, SERVICES AND RELATED GRAPHICS OBTAINED THROUGH THE [STORENAME] WEB SITE, OR OTHERWISE 
ARISING OUT OF THE USE OF THE [STORENAME] WEB SITE, WHETHER BASED ON CONTRACT, TORT, NEGLIGENCE, STRICT LIABILITY OR OTHERWISE, EVEN IF [STORENAME] OR ANY OF ITS SUPPLIERS HAS BEEN 
ADVISED OF THE POSSIBILITY OF DAMAGES. BECAUSE SOME STATES/JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION 
MAY NOT APPLY TO YOU. IF YOU ARE DISSATISFIED WITH ANY PORTION OF THE [STORENAME] WEB SITE, OR WITH ANY OF THESE TERMS OF USE, YOUR SOLE AND EXCLUSIVE REMEDY IS TO DISCONTINUE USING THE 
[STORENAME] WEB SITE.<BR><BR>SERVICE CONTACT : <a href="MAILTO:[STOREEMAIL]">[STOREEMAIL]</a><BR><BR><SPAN class=SubHead>TERMINATION/ACCESS RESTRICTION</SPAN><BR><BR>[STORENAME] reserves 
the right, in its sole discretion, to terminate your access to the [STORENAME] Web Site and the related services or any portion thereof at any time, without notice. GENERAL To the maximum 
extent permitted by law, this agreement is governed by the laws of the State of Washington, U.S.A. and you hereby consent to the exclusive jurisdiction and venue of courts in King County, 
Washington, U.S.A. in all disputes arising out of or relating to the use of the [STORENAME] Web Site. Use of the [STORENAME] Web Site is unauthorized in any jurisdiction that does not give 
effect to all provisions of these terms and conditions, including without limitation this paragraph. You agree that no joint venture, partnership, employment, or agency relationship exists 
between you and [STORENAME] as a result of this agreement or use of the [STORENAME] Web Site. [STORENAME]''s performance of this agreement is subject to existing laws and legal process, and 
nothing contained in this agreement is in derogation of [STORENAME]''s right to comply with governmental, court and law enforcement requests or requirements relating to your use of the 
[STORENAME] Web Site or information provided to or gathered by [STORENAME] with respect to such use. If any part of this agreement is determined to be invalid or unenforceable pursuant to 
applicable law including, but not limited to, the warranty disclaimers and liability limitations set forth above, then the invalid or unenforceable provision will be deemed superseded by a valid, 
enforceable provision that most closely matches the intent of the original provision and the remainder of the agreement shall continue in effect. Unless otherwise specified herein, 
this agreement constitutes the entire agreement between the user and [STORENAME] with respect to the [STORENAME] Web Site and it supersedes all prior or contemporaneous communications and 
proposals, whether electronic, oral or written, between the user and [STORENAME] with respect to the [STORENAME] Web Site. A printed version of this agreement and of any notice given in 
electronic form shall be admissible in judicial or administrative proceedings based upon or relating to this agreement to the same extent an d subject to the same conditions as other business 
documents and records originally generated and maintained in printed form. It is the express wish to the parties that this agreement and all related documents be drawn up in English.<BR><BR>
<SPAN class=SubHead>COPYRIGHT AND TRADEMARK NOTICES:</SPAN><BR><BR>All contents of the [STORENAME] Web Site are: [COPYRIGHT] and/or its suppliers. All rights reserved.<BR><BR>
<SPAN class=SubHead>TRADEMARKS</SPAN><BR><BR>The names of actual companies and products mentioned herein may be the trademarks of their respective owners.<BR><BR>The example companies, 
organizations, products, people and events depicted herein are fictitious. No association with any real company, organization, product, person, or event is intended or should be inferred.
<BR><BR>Any rights not expressly granted herein are reserved.<BR><BR><SPAN class=SubHead>NOTICES AND PROCEDURE FOR MAKING CLAIMS OF COPYRIGHT INFRINGEMENT</SPAN><BR><BR>Pursuant to Title 17, 
United States Code, Section 512(c)(2), notifications of claimed copyright infringement under United States copyright law should be sent to Service Provider''s Designated Agent. 
ALL INQUIRIES NOT RELEVANT TO THE FOLLOWING PROCEDURE WILL RECEIVE NO RESPONSE. See Notice and Procedure for Making Claims of Copyright Infringement. </SPAN><BR></P>
	','
<P><SPAN class=Normal>[STORENAME] is committed to protecting your privacy and developing technology that gives you the most powerful and safe online experience. 
This Statement of Privacy applies to the [STORENAME] Web site and governs data collection and usage. By using the [STORENAME] website, 
you consent to the data practices described in this statement.<BR><BR><STRONG><SPAN class=SubHead>Collection of your Personal Information</SPAN><BR><BR>
</STRONG>[STORENAME] collects personally identifiable information, such as your e-mail address, name, home or work address or telephone number. 
[STORENAME] also collects anonymous demographic information, which is not unique to you, such as your ZIP code, age, gender, preferences, interests and favorites.<BR><BR>
There is also information about your computer hardware and software that is automatically collected by [STORENAME]. 
This information can include: your IP address, browser type, domain names, access times and referring Web site addresses. 
This information is used by [STORENAME] for the operation of the service, to maintain quality of the service, and to provide general statistics regarding use of the 
[STORENAME] Web site.<BR><BR>Please keep in mind that if you directly disclose personally identifiable information or personally sensitive data through [STORENAME] 
public message boards, this information may be collected and used by others. Note: [STORENAME] does not read any of your private online communications.<BR><BR>
[STORENAME] encourages you to review the privacy statements of Web sites you choose to link to from [STORENAME] so that you can understand how those Web sites collect, 
use and share your information. [STORENAME] is not responsible for the privacy statements or other content on Web sites outside of the [STORENAME] and [STORENAME] 
family of Web sites.<BR><BR><STRONG><SPAN class=SubHead>Use of your Personal Information</SPAN><BR><BR></STRONG>[STORENAME] collects and uses your personal information to operate the 
[STORENAME] Web site and deliver the services you have requested. [STORENAME] also uses your personally identifiable information to inform you of other products or services available from 
[STORENAME] and its affiliates. [STORENAME] may also contact you via surveys to conduct research about your opinion of current services or of potential new services that may be offered.<BR><BR>
[STORENAME] does not sell, rent or lease its customer lists to third parties. 
[STORENAME] may, from time to time, contact you on behalf of external business partners about a particular offering that may be of interest to you. In those cases, your unique personally 
identifiable information (e-mail, name, address, telephone number) is not transferred to the third party. In addition, 
[STORENAME] may share data with trusted partners to help us perform statistical analysis, send you email or postal mail, 
provide customer support, or arrange for deliveries. All such third parties are prohibited from using your personal information 
except to provide these services to [STORENAME], and they are required to maintain the confidentiality of your information.<BR><BR>
[STORENAME] does not use or disclose sensitive personal information, such as race, religion, or political affiliations, without your explicit consent.<BR><BR>
[STORENAME] keeps track of the Web sites and pages our customers visit within [STORENAME], in order to determine what [STORENAME] services are the most popular. 
This data is used to deliver customized content and advertising within [STORENAME] to customers whose behavior indicates that they are interested in a particular subject area.<BR><BR>
[STORENAME] Web sites will disclose your personal information, without notice, only if required to do so by law or in the good faith belief that such action is necessary to: (a) 
conform to the edicts of the law or comply with legal process served on [STORENAME] or the site; (b) protect and defend the rights or property of [STORENAME]; 
and, (c) act under exigent circumstances to protect the personal safety of users of [STORENAME], or the public.<BR><BR><STRONG><SPAN class=SubHead>Use of Cookies</SPAN><BR><BR>
</STRONG>The [STORENAME] Web site use "cookies" to help you personalize your online experience. A cookie is a text file that is placed on your hard disk by a Web page server. 
Cookies cannot be used to run programs or deliver viruses to your computer. Cookies are uniquely assigned to you, and can only be read by a web server in the domain that issued the cookie to you.<BR><BR>
One of the primary purposes of cookies is to provide a convenience feature to save you time. The purpose of a cookie is to tell the Web server that you have returned to a specific page. 
For example, if you personalize [STORENAME] pages, or register with [STORENAME] site or services, a cookie helps [STORENAME] to recall your specific information on subsequent visits. 
This simplifies the process of recording your personal information, such as billing addresses, shipping addresses, and so on. When you return to the same [STORENAME] Web site, 
the information you previously provided can be retrieved, so you can easily use the [STORENAME] features that you customized.<BR><BR>You have the ability to accept or decline cookies. 
Most Web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. If you choose to decline cookies, you may not be able to 
fully experience the interactive features of the [STORENAME] services or Web sites you visit.<BR><BR><STRONG><SPAN class=SubHead>Security of your Personal Information</SPAN><BR><BR></STRONG>
[STORENAME] secures your personal information from unauthorized access, use or disclosure. [STORENAME] secures the personally identifiable information you provide on computer servers in a 
controlled, secure environment, protected from unauthorized access, use or disclosure. When personal information (such as a credit card number) is transmitted to other Web sites, it is 
protected through the use of encryption, such as the Secure Socket Layer (SSL) protocol.<BR><BR><STRONG><SPAN class=SubHead>Changes to this Statement</SPAN><BR><BR></STRONG>
[STORENAME] will occasionally update this Statement of Privacy to reflect company and customer feedback. [STORENAME] encourages you to periodically review this Statement to be informed of how 
[STORENAME] is protecting your information.<BR><BR><STRONG><SPAN class=SubHead>Contact Information</SPAN><BR><BR></STRONG>[STORENAME] welcomes your comments regarding this Statement of Privacy. 
If you believe that [STORENAME] has not adhered to this Statement, please contact [STORENAME] at <A href="mailto:[STOREEMAIL]">[STOREEMAIL]</A>. 
We will use commercially reasonable efforts to promptly determine and remedy the problem. </SPAN></P>
')
GO

insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Home','../../storecontrols/defaultview.ascx','../../storecontrols/DefaultViewAdmin.ascx','
<b>Overview</b><br><br>This is the "Homepage" control.  This is the default content viewed when a user come to your website.  This content can be edited by clicking the "Edit" link to the left of this help link. <br><br><b>Administration Instruction</b><br><br><i><b>Editing Content</b></i><br><br>Once you have clicked the "Edit" link, you will be presented with a WYSIWYG editing control (Free Text Box).  Simply use this editing control just as you would use Word or FrontPage to edit a document.  If you need to fine-tune the HTML, click the "HTML" tab at the bottom of the control. To Save, click the "Save" link just below the Editor.  To cancel and start over, click the "Cancel" link just below the Editor.<br><br><i><b>Steps</b></i><br><br>1) Click the "Edit" link<br>2) Use the Rich HTML Editor to add content<br>3) Click "Save" to save or "Cancel" to cancel<br><br>NOTE: You must be running Internet Explorer (IE) version 5.0 or later to use the Editor Control.'
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Skin Admin','../../admin/skin/SkinUploader.ascx','../../admin/skin/SkinUploader.ascx','
<P><STRONG>Overview</STRONG></P><P>The Skinning Control allows you to upload new skins, select a desired skin, and delete old skins.</P><P><STRONG>Administration Instructions</STRONG></P><P><STRONG><U>Add Skin</U></STRONG></P><P>To upload a new skin, go to the "Skins"&nbsp;control and click "Add Skin", then browse to the skin and upload it.</P><P><STRONG><EM>Steps</EM></STRONG></P><P>1) Click "Admin Tools" from the menu<BR>2) Click "Skins" from the Admin Menu<BR>3) Click the "Add Skin" link<BR>4) Click the "Browse" button<BR>5) Select the Skin Zip<BR>6) Click the "Open" button<BR>7) Click the "Install" button</P><P><STRONG><U>Assign a Skin</U></STRONG></P><P>To assign a skin, go to the "Skins"&nbsp;control and click "Edit Skin", then select the desired skin from the dropdown and then click "Update Skin".</P><P><EM>NOTE: You will not see a change until your next navigation.</EM></P><P><STRONG><EM>Steps</EM></STRONG></P><P>1) Click "Admin Tools" from the menu<BR>2) Click "Skins" from the Admin Menu<BR>3) Click the "Edit Skin" link<BR>4) Select the desired Skin<BR>5) Click the "Update Skin" link</P><P><STRONG><U>Delete Skin</U></STRONG></P><P>To delete a Skin, first apply another skin to the site (deleting a in use skin will have adverse reactions). Then got the "Edit Skins", select the desired Skin, and then click the "Delete Skin" link.</P><P><STRONG><EM>Steps</EM></STRONG></P><P>1) Click "Admin Tools" from the menu<BR>2) Click "Skins" from the Admin Menu<BR>3) Click the "Edit Skin" link<BR>4) Select the desired Skin<BR>5) Click the "Delete Skin" link</P>'
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Product List','../../storecontrols/ProductList.ascx','../../storecontrols/ProductAdmin.ascx','
<P><B>Overview</B><BR><BR>This is the Produc Administration Control.&nbsp; This control allows you to add, edit, and if appropriate delete products.<BR><BR><B>Administration Instruction</B><BR><BR><I><B>New Product</B></I><BR><BR>To add a product, click "New Product", then choose the category, name, number, cost, image, and descriptiion&nbsp;of the product&nbsp;.<BR><BR><I><B>Steps</B></I><BR><BR>1) Click the "New Product" link<BR>2) Enter the Product Name in the "Name" Textbox<BR>3) Enter the Product Number in the "Number" Textbox<BR>4) Enter the Product Cost in the "Cost" Textbox<BR>5) Select the Product Image from the "Image" Dropdown List<BR>6) Enter the Product Description in the "Description" Textbox<BR>7) Click "Save" to save or "Cancel" to cancel<BR><BR><STRONG><EM>Edit Product</EM></STRONG><BR><BR>To edit a product, click "Edit Product", then click the "Edit" link to the left of the product you&nbsp;want to edit. Next make the desired changes as needed.<BR><BR><I><B>Steps</B></I><BR><BR>1) Click the "Edit Product" Link<BR>2) Click the "Edit" Link to the Right of the Product You Want to Edit<BR>3) Enter a New Product Name in the "Name" Textbox if Needed<BR>4) Enter a New Product Number in the "Number" Textbox if Needed<BR>5) Enter a New Product Cost in the "Cost" Textbox if Needed<BR>6) Select a New Product Image from the "Image" Dropdown List if Needed<BR>7) Enter a New Product Description in the "Description" Textbox if Needed<BR>8) Click "Save" to save or "Cancel" to cancel<BR></P>'
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Product Details','../../storecontrols/ProductDetails.ascx','../../storecontrols/ProductDetails.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Check Out','../../storecontrols/CheckOut.ascx','../../storecontrols/CheckOut.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Login','../../storecontrols/Login.ascx','../../storecontrols/Login.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Order Details','../../storecontrols/OrderDetails.ascx','../../storecontrols/OrderDetails.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Order List','../../storecontrols/OrderList.ascx','../../storecontrols/OrderList.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Register','../../storecontrols/Register.ascx','../../storecontrols/Register.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Reviews','../../storecontrols/Reviews.ascx','../../storecontrols/ReviewAdmin.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Search Results','../../storecontrols/SearchResults.ascx','../../storecontrols/SearchResults.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Shopping Cart','../../storecontrols/ShoppingCart.ascx','../../storecontrols/ShoppingCart.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Add To Cart','../../storecontrols/AddToCart.ascx','../../storecontrols/AddToCart.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Security Error Control','../../controls/SecurityErrorControl.ascx','../../controls/SecurityErrorControl.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Category Admin','../../storecontrols/defaultview.ascx','../../storecontrols/CategoryAdmin.ascx','
<P><B>Overview</B><BR><BR>This is the Category Administration Control.&nbsp; This control allows you to add, edit, and if appropriate delete categories.<BR><BR><B>Administration Instruction</B><BR><BR><I><B>New Category</B></I><BR><BR>To add a category, click "New Category", then enter the category name&nbsp;and&nbsp;a&nbsp;description.<BR><BR><I><B>Steps</B></I><BR><BR>1) Click the "New Category" link<BR>2) Enter the Category Name in the "Name" Textbox<BR>3) Enter the Category Description in the "Description" Textbox<BR>4) Click "Save" to save or "Cancel" to cancel<BR><BR><STRONG><EM>Edit Category</EM></STRONG><BR><BR>To edit a category, click "Edit Category", then click the "Edit" link to the left of the category you&nbsp;want to edit. Next make the desired changes as needed.<BR><BR><I><B>Steps</B></I><BR><BR>1) Click the "Edit Category" link<BR>2) Click the "Edit" link to the Right of the Category to be Edited<BR>3) Enter a New Category Name in the "Name" Textbox if Needed<BR>4) Enter a New Category Description in the "Description" Textbox if Needed<BR>5) Click "Save" to save or "Cancel" to cancel<BR></P>'
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Terms','../../admin/store/Terms.ascx','../../admin/store/TermsAdmin.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Privacy','../../admin/store/Privacy.ascx','../../admin/store/PrivacyAdmin.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Store Information','../../admin/store/StoreAdmin.ascx','../../admin/store/StoreAdmin.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'Help','../../admin/store/Help.ascx','../../admin/store/Help.ascx',''
GO
insert StoreNuke_StoreControls ( StoreControlName,StoreControlPath,StoreControlAdminPath,StoreControlHelp )  select 'OrderAdmin','../../storecontrols/OrderAdmin.ascx','../../storecontrols/OrderAdmin.ascx',''
GO

insert into StoreNuke_StoreControlSettings 
(StoreControlID,SettingName,SettingValue) 
values 
(1,'PageTitle','Welcome to the home of StoreNuke.Net') 
GO  

insert into StoreNuke_StoreControlSettings 
(StoreControlID,SettingName,SettingValue) 
values 
(1,'PageContent','
<TABLE id=Table3 cellSpacing=0 cellPadding=2 width=600 border=0>
<TBODY>
<TR vAlign=top>
<TD>
<TABLE id=Table4 width=300>
<TBODY>
<TR vAlign=top>
<TD>
<P><FONT color=#000000><SPAN class=NormalDouble><STRONG>The New Commerce Starter for Professionals<BR></STRONG><BR>As we all know, the starter kits are very basic and can really use some features (like a backend ;).&nbsp; With StoreNuke.Net project is out to change all this.&nbsp; StoreNuke.Net (based on the latest Commerce Starter Kit) will offer the following enhancements:</SPAN> </FONT></P><SPAN class=NormalDouble>
<UL>
<LI>Skinning<BR>Very Similar to DNN Skinning (very simple and easy) 
<LI>Control Driven Architecture<BR>Everything is a control being dynamically loaded 
<LI>Provider Based (very enhanced) Menu System 
<LI>Provider Based Gateway Plug-in Architecture (including PayPal and Authorize.Net gateways already in place and ready to us). 
<LI>Backend Support for Adding/Editing Categories, Products, etc <BR><BR></LI></UL></SPAN></TD></TR></TBODY></TABLE></TD>
<TD align=left><IMG src="http://www.storenuke.net/ProductImages/image.gif" width=309 border=0> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=NormalDouble><I>Blast off in a <A class="" title="" href="Default.aspx?scid=4&amp;productID=373" target=""><B>Pocket Protector Rocket Pack</B></A></I></SPAN></TD>
<TD>&nbsp; </TD></TR>
<TR vAlign=top>
<TD class=NormalDouble colSpan=3>
<P class=NormalDouble>StoreNuke.Net -&nbsp; <A href="">http://www.storenuke.net</A><BR>Copyright (c) 2005<BR>by Robert J Collins ( <A href="mailto:info@willowtreesoftware.com">info@willowtreesoftware.com</A> ) of WillowTree Software, Inc. ( <A href="http://www.willowtreesoftware.com">http://www.willowtreesoftware.com</A> )</P>
<P class=NormalDouble>Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:</P>
<P class=NormalDouble>The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.</P>
<P class=NormalDouble>THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</P></TD></TR></TBODY></TABLE>
') 
GO 

insert into StoreNuke_StoreControlSettings 
(StoreControlID,SettingName,SettingValue) 
values 
(15,'PageTitle','Welcome to the home of StoreNuke.Net') 
GO 

insert into StoreNuke_StoreControlSettings 
(StoreControlID,SettingName,SettingValue) 
values 
(15,'PageContent','
<TABLE id=Table3 cellSpacing=0 cellPadding=2 width=600 border=0>
<TBODY>
<TR vAlign=top>
<TD>
<TABLE id=Table4 width=300>
<TBODY>
<TR vAlign=top>
<TD>
<P><FONT color=#000000><SPAN class=NormalDouble><STRONG>The New Commerce Starter for Professionals<BR></STRONG><BR>As we all know, the starter kits are very basic and can really use some features (like a backend ;-).&nbsp; The StoreNuke.Net project is out to change all this.&nbsp; StoreNuke.Net (based on the latest Commerce Starter Kit) will offer the following enhancements:</SPAN> </FONT></P><SPAN class=NormalDouble>
<UL>
<LI>Skinning<BR>Very Similar to DNN Skinning (very simple and easy) 
<LI>Control Driven Architecture<BR>Everything is a control being dynamically loaded 
<LI>Provider Based (very enhanced) Menu System 
<LI>Provider Based Gateway Plug-in Architecture (including PayPal and Authorize.Net gateways already in place and ready to us). 
<LI>Backend Support for Adding/Editing Categories, Products, etc <BR><BR></LI></UL></SPAN></TD></TR></TBODY></TABLE></TD>
<TD align=left><IMG src="http://www.storenuke.net/ProductImages/image.gif" width=309 border=0> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class=NormalDouble><I>Blast off in a <A class="" title="" href="Default.aspx?scid=4&amp;productID=373" target=""><B>Pocket Protector Rocket Pack</B></A></I></SPAN></TD>
<TD>&nbsp; </TD></TR>
<TR vAlign=top>
<TD class=NormalDouble colSpan=3>
<P class=NormalDouble>StoreNuke.Net -&nbsp; <A href="">http://www.storenuke.net</A><BR>Copyright (c) 2005<BR>by Robert J Collins ( <A href="mailto:info@willowtreesoftware.com">info@willowtreesoftware.com</A> ) of WillowTree Software, Inc. ( <A href="http://www.willowtreesoftware.com">http://www.willowtreesoftware.com</A> )</P>
<P class=NormalDouble>Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:</P>
<P class=NormalDouble>The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.</P>
<P class=NormalDouble>THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</P></TD></TR></TBODY></TABLE>
') 
GO
-- End Script